package com.github.crush0.myblog.dao;

import com.github.crush0.myblog.entity.SortInfo;
import com.github.crush0.myblog.entity.SortInfoExample;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;
@Mapper
public interface SortInfoMapper {
    int deleteByPrimaryKey(Long id);

    int insert(SortInfo record);

    int insertSelective(SortInfo record);

    List<SortInfo> selectByExample(SortInfoExample example);

    @Select("select * from tbl_sort_info where id=#{id}")
    SortInfo selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(SortInfo record);

    @Update("update tbl_sort_info set name = #{name},modified_by = #{modified_by} where id=#{id}")
    void updateByPrimaryKey(SortInfo record);

    @Select("select * from tbl_sort_info")
    List<SortInfo> selectAll();
}